select a.dftpic as dftpic1, b.Latitude as b_Latitude, b.Longitude as b_Longitude,* from [houses] a, [base_property] b, [base_cityDistrict] c where audit=1 and a.pid = b.pid and b.did = c.id and a.del=0 and a.locker=0 and b.del=0 and b.locker=0 and a.isShowEn=0 and (b.cnpropertyname like '%Ambassy Court%' or b.enpropertyname like '%Ambassy Court%') order by updateTime Desc, a.dftpic desc
Open kitchen. Extremely big living and dinning. Floor heating, throughout wall insulation, daikin central ac, double glazing windows. Smeg oven, Coway filtered ...
New decoration, fully furnished, will floor heating, with club, playground, cloakroom, A/C, quality compound, about 3mins walking to L10 Shanghai Library statio...